Basic SQL Server query statements
1> use AdventureWorks; 2> select DepartmentID, Name from HumanResources.Department where GroupName = 'Executive General and Administration'; 3> go +--------------+----------------------------+ | DepartmentID | Name | +--------------+----------------------------+ | 9 | Human Resources | | 10 | Finance | | 11 | Information Services | | 14 | Facilities and Maintenance | | 16 | Executive | +--------------+----------------------------+ (5 rows affected) 1>